UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3UnZn0C0PQjeNa4y3PszTjm3WuJWR5n0MuFUhMoIYVA='
WHERE
key_id = 'cca55afd8de5f95a82d1a2291a69d7ad165ac579b5d510cb47c923a5725e4545'
AND (
token = '3UnZn0C0PQjeNa4y3PszTjm3WuJWR5n0MuFUhMoIYVA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)