UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fZ7dl3dPBIpYZin6jtGU1Ra+shuR5OQuglmU6LgwTv0='
WHERE
key_id = '704821f13ff1fa171650bc5214cc624a5053bb757aa1bdbc1943180731e70aea'
AND (
token = 'fZ7dl3dPBIpYZin6jtGU1Ra+shuR5OQuglmU6LgwTv0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)