UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9fIdl9qtRYiN5PtI/HbrMA14MunBk6MmSlLXjXP7TrY='
WHERE
key_id = 'a1d227af82a1aa831d25a0c0374720d6ee5776596f3c6a9357a12b47e7d2cc22'
AND (
token = '9fIdl9qtRYiN5PtI/HbrMA14MunBk6MmSlLXjXP7TrY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)