UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7sgzDSE8UCTe47f3dtXsapErF4llgHdujqVUOfC5a8o='
WHERE
key_id = '7ccbd094bcaff9e02d6ee51ff302e925b64cdcdee672cfc11d34194fed8ddc67'
AND (
token = '7sgzDSE8UCTe47f3dtXsapErF4llgHdujqVUOfC5a8o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)