UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'W3o93WOU4kVMNJKCB+yFlPOUkI6UsmXLSqLvA6+9yio='
WHERE
key_id = '0e8d094acdddead180afb54af290eb246483e62ee4512d9fbfea8157c588c227'
AND (
token = 'W3o93WOU4kVMNJKCB+yFlPOUkI6UsmXLSqLvA6+9yio='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)