UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'o3KB+XUAXJ6iGrYJTzNOcHrSW8Luwlu/tlDyVr19br0='
WHERE
key_id = 'dd97dee0c2a107ba3bef94bac8824808a0c08b2408226dcd39926c7dec090ae1'
AND (
token = 'o3KB+XUAXJ6iGrYJTzNOcHrSW8Luwlu/tlDyVr19br0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)