UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZG1vFzW9YK2TtiXAbVJ/rFbkVxNkeJ8n2Ayau/IvxCo='
WHERE
key_id = 'a23e950639462042b834bf9a524d8fdb8504d704b35481d39080399656391a5f'
AND (
token = 'ZG1vFzW9YK2TtiXAbVJ/rFbkVxNkeJ8n2Ayau/IvxCo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)