UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'o7ykIR1fH6iczwh5y/1gvdGXKGmLcm27nmVqAvIrue4='
WHERE
key_id = '1f789a03fbb3a0ec605956528e527fe58c3cacaed4520302fd06ad66a768c357'
AND (
token = 'o7ykIR1fH6iczwh5y/1gvdGXKGmLcm27nmVqAvIrue4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)