UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/zGXtymcN2enkZvrP+95cu0pLWJx23yswBUK5dseQZI='
WHERE
key_id = '1687c6a09b751bbf0943425ba6f054435b767b0773beb6202c49009975de848a'
AND (
token = '/zGXtymcN2enkZvrP+95cu0pLWJx23yswBUK5dseQZI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)