UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/oterKrfWT98Am/pLMCtpPHZLcu7OOpwVPgfHZMxQ/c='
WHERE
key_id = '77d1afff3f9d5539b4cf690351ced03cf063ac8d0faea891df267972aae5041b'
AND (
token = '/oterKrfWT98Am/pLMCtpPHZLcu7OOpwVPgfHZMxQ/c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)