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