UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'imDDSM+UOJK1QhyChsMO4qrPJdYaBocHfUiWeh+206w='
WHERE
key_id = '506dad6b278557a15169a046be7eecbcdad822cf11a952d1cc60c95a8b01cdc0'
AND (
token = 'imDDSM+UOJK1QhyChsMO4qrPJdYaBocHfUiWeh+206w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)