UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '33ZbaovGqWdKB+/sKhA9WouVETNZvMrB+ZSvPX08ztU='
WHERE
key_id = '671493f732a786f2a9d31b33be0e4c90496fa51595f6c0aa769d9266bac89d5b'
AND (
token = '33ZbaovGqWdKB+/sKhA9WouVETNZvMrB+ZSvPX08ztU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)