UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Mvaa8ITcXHjFUhFc4KeWlRM3fXaHBXn376X8yDS7fEY='
WHERE
key_id = 'bdcff254dadecf5e07243204ee3791bcf697590bf5b50def4bc73d5dcbb1f6ec'
AND (
token = 'Mvaa8ITcXHjFUhFc4KeWlRM3fXaHBXn376X8yDS7fEY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)