UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'agBWVIMib2yiqBrcrsNPSQz4cXkRCIusnoaiI+cGoSk='
WHERE
key_id = '0de41de7a80565b63b53f2482ce4f83731fe0d8fe36e34ec039a09fc899b1a47'
AND (
token = 'agBWVIMib2yiqBrcrsNPSQz4cXkRCIusnoaiI+cGoSk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)