UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LwP2JypnnJ8i/i7stnWl+EcFS/2HXs/11YVW/XN5jbY='
WHERE
key_id = '3c3acde87cf7f64937d3ef66b36797337aa9c415a84d0e004897b9d47853599d'
AND (
token = 'LwP2JypnnJ8i/i7stnWl+EcFS/2HXs/11YVW/XN5jbY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)