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