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