UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XggmXaTX5+QfmEVlDl6ZarHj87DZiUu0AcL68dg1uvE='
WHERE
key_id = 'f0506c2d38993a4124237d026ae930eb1578fba2c89ad1986d4faf2c03759496'
AND (
token = 'XggmXaTX5+QfmEVlDl6ZarHj87DZiUu0AcL68dg1uvE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)