UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'AI9e/rY1Ist/kDRCctxDCWN+7xeiOIqmyGTBxOFHMZk='
WHERE
key_id = 'e47b6311a3f778b7a939c1ea5ec3c8b9076ea79b0924287b6d3bbe710d95f1a8'
AND (
token = 'AI9e/rY1Ist/kDRCctxDCWN+7xeiOIqmyGTBxOFHMZk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)