UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'x+HDnVJmFjJ379nEaQxPkfGHtshuXUPrSKxVTA49RSc='
WHERE
key_id = '4fc4c7040d5ea9983e49b8ed0e8ef023d9d03bce8e03435fe53342c87386d1d9'
AND (
token = 'x+HDnVJmFjJ379nEaQxPkfGHtshuXUPrSKxVTA49RSc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)