UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'W/fI2qpYhpWkZH+3Wwh+n4J0ip6jCPIRz7O2zCSyKC4='
WHERE
key_id = 'e5725cd344db727cd706e87d4e7f82268387b04497bbe56e9a285df0b6184679'
AND (
token = 'W/fI2qpYhpWkZH+3Wwh+n4J0ip6jCPIRz7O2zCSyKC4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)