UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KMag+qkTo2CQ9FdnNHrgHix4Hsj2hYIh4BDMjoybLYI='
WHERE
key_id = '4e2a7d0e9b1a7fd97c8684c842a0418877bc6a903399892dbc716354ab48aede'
AND (
token = 'KMag+qkTo2CQ9FdnNHrgHix4Hsj2hYIh4BDMjoybLYI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)