UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XyDNWtRt23QwWZL0E7/YtCPAREA4PxG2A61+Nn0rxz8='
WHERE
key_id = 'd08f90c3c65d770858c568eb4133801c45d5613a989412fb9b6a7ebc9a62b0cd'
AND (
token = 'XyDNWtRt23QwWZL0E7/YtCPAREA4PxG2A61+Nn0rxz8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)