UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1ts96jADfZZ3RbPmjApxs2wD+cV3Ye3m3EPRgER9jcM='
WHERE
key_id = 'c483eda2de6baa1d30ecabbc1bcbe739cec88592c6bab35bae3c7a9a0dde3340'
AND (
token = '1ts96jADfZZ3RbPmjApxs2wD+cV3Ye3m3EPRgER9jcM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)