UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z16EAe7B1tL6ne7EL9wSunaNxj2UTUXeV4Kknp/Q03Y='
WHERE
key_id = 'efaf258aa81025fc9b6dd619735a5706c2f11bad2bdf86859e1ef19a15842629'
AND (
token = 'z16EAe7B1tL6ne7EL9wSunaNxj2UTUXeV4Kknp/Q03Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)