UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+XUsCkTdIsTLJLfHRWVONPtUu/unh+qK4wbxe9J+7xE='
WHERE
key_id = 'af85426cf045127f5a8b85c23e3016f8db272d9ce631547f2f257d19fb5d2ee3'
AND (
token = '+XUsCkTdIsTLJLfHRWVONPtUu/unh+qK4wbxe9J+7xE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)