UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'O0MIXmrYtj3pcVdgOFqcL5jH4DrZCpErDrKPLVgz0LA='
WHERE
key_id = 'f8ecfde1c563dfe4e44f8ab334a55fad2d9441acffd384a239b1160ca3d4174b'
AND (
token = 'O0MIXmrYtj3pcVdgOFqcL5jH4DrZCpErDrKPLVgz0LA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)