UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hCk1HeF9dxmWegGTl67fYXy7i2JrN/uwsK/Z/lx4tbc='
WHERE
key_id = '48414c683488184d0dd09415542f0a79a871346f5d8877499040a621ad2128d0'
AND (
token = 'hCk1HeF9dxmWegGTl67fYXy7i2JrN/uwsK/Z/lx4tbc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)