UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X8N0wIdMR23W43OIX/vfLOVLiAb+SqE3OcVpeXHOd58='
WHERE
key_id = '74410c41e149934886c8c4245f922f7c3a0ac9cfeae7157a262f3924d98abeb5'
AND (
token = 'X8N0wIdMR23W43OIX/vfLOVLiAb+SqE3OcVpeXHOd58='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)