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