UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'n3hmFk8KkRstPIwiUwbF8ZBIUaKNB5p/7D3218EQOT4='
WHERE
key_id = '28c76df4c37b55b194866f1796fca8915a6c1a58f554043918b68793816bdd28'
AND (
token = 'n3hmFk8KkRstPIwiUwbF8ZBIUaKNB5p/7D3218EQOT4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)