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